﻿CREATE TABLE [dbo].[AW_DocTakeUpAuction] (
    [DocAucId]      UNIQUEIDENTIFIER NULL,
    [DocAucTitle]   NVARCHAR (250)   NULL,
    [REN]           NVARCHAR (500)   NULL,
    [Lister]        NVARCHAR (500)   NULL,
    [DocDate]       DATETIME         NULL,
    [Premise]       NVARCHAR (500)   NULL,
    [Price]         NVARCHAR (250)   NULL,
    [AuctionDate]   DATETIME         NULL,
    [Remarks]       NVARCHAR (MAX)   NULL,
    [Bank]          NVARCHAR (500)   NULL,
    [ContactPerson] NVARCHAR (500)   NULL,
    [ContactNo]     NVARCHAR (50)    NULL,
    [FaxNo]         NVARCHAR (50)    NULL,
    [CPRemarks]     NVARCHAR (MAX)   NULL,
    [Commission]    NVARCHAR (250)   NULL,
    [Purchaser]     NVARCHAR (500)   NULL,
    [NRIC]          NVARCHAR (50)    NULL,
    [Disbursement]  NVARCHAR (250)   NULL,
    [Address]       NVARCHAR (500)   NULL,
    [PContactNo]    NVARCHAR (50)    NULL,
    [CreateBy]      UNIQUEIDENTIFIER NULL,
    [CreateDate]    DATETIME         NULL,
    [UpdateBy]      UNIQUEIDENTIFIER NULL,
    [UpdateDate]    DATETIME         NULL,
    [StatusDelete]  TINYINT          NULL
);

